Other examples of a Prefilter
In the previous example we specified ‘equals’ in both Conditions to find an exact match for ‘2’ and for ‘F’ (this search function is case sensitive). However, you have other alternatives such as ‘like’ which will find approximate matches – you will need to include the wildcard %.
For example, you may want to find any Department beginning with Vic:
Note the use of the wildcard %.
You might also use the ‘between’ search option when looking for numerical values:
